home *** CD-ROM | disk | FTP | other *** search
/ Mastering Web Site Development / Microsoft Mastering Web Site Development (Microsoft) (1997).iso / Media / SampApps / AdvWorks / AWVB5Demo.EXE / AWDrop.SQL < prev    next >
Encoding:
Text File  |  1996-10-04  |  1.6 KB  |  47 lines
  1. /******************************************************************************/
  2. /*                                                                            */
  3. /* Name: Drop Adventure Works Database.SQL                                    */
  4. /*                                                                            */
  5. /* Date: October 3, 1996                                                      */
  6. /*                                                                            */
  7. /* Demo: Adventure Works Demo                                                 */
  8. /*                                                                            */
  9. /* WARNING: Executing this script will COMPLETELY delete the AWData           */
  10. /*          (Adventure Works) database and its associated data                */
  11. /*          device.                                                           */
  12. /*                                                                            */
  13. /******************************************************************************/
  14.  
  15. SET NOCOUNT ON
  16.  
  17. DECLARE @dttm varchar(55)
  18. SELECT @dttm=convert(varchar,getdate(),113)
  19. RAISERROR('Beginning Drop Adventure Works Database.SQL at %s ....',1,1,@dttm) with nowait
  20. GO
  21.  
  22. USE master
  23. GO
  24.  
  25. RAISERROR('Dropping Adventure Works Database ....',1,1) with nowait
  26. GO
  27.  
  28. DROP DATABASE AWData
  29. GO
  30.  
  31. RAISERROR('Dropping Data Device ....',1,1) with nowait
  32. GO
  33.  
  34. sp_dropdevice AWData, DELFILE
  35. GO
  36.  
  37. DECLARE @dttm varchar(55)
  38. SELECT @dttm=convert(varchar,getdate(),113)
  39. RAISERROR('Completed Drop Adventure Works Database.SQL at %s.',1,1,@dttm) with nowait
  40. GO
  41.  
  42.  
  43.  
  44.  
  45.  
  46.  
  47.